UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g5CpdQ0gSysxFPgEKxe6ErxxVTqWfAUfyNeiYZ89Qw0='
WHERE
key_id = '3a58a1d0e14ce4323c30ad41f93e9f031379171b879780375050c22a794687d6'
AND (
token = 'g5CpdQ0gSysxFPgEKxe6ErxxVTqWfAUfyNeiYZ89Qw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)