UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4HuXsdG28P6lbjvKZVi0a76DwoXMiG2RmYgsY/voCeY='
WHERE
key_id = '21a2f50fdca5cb3ace06b31c23323368e9a43b05883f95b378c12f3920aaf57c'
AND (
token = '4HuXsdG28P6lbjvKZVi0a76DwoXMiG2RmYgsY/voCeY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)