UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g7GdYCEW06KuRULR5TvUDd7AZA7P4a8KAkw5KkuvbAQ='
WHERE
key_id = 'adbbb883cb0b899fd51f8847d1b70389b45ee6a31c0dd309943748a2f2ca48b3'
AND (
token = 'g7GdYCEW06KuRULR5TvUDd7AZA7P4a8KAkw5KkuvbAQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)