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