UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b36lV7n9LbnJ1sKBFdnPBjP+YWpHCrf+1khWxSMha3M='
WHERE
key_id = '47d9d0ab15ff4e7006a30a74a27341971930187d57228ef6ad8ed53701cc6233'
AND (
token = 'b36lV7n9LbnJ1sKBFdnPBjP+YWpHCrf+1khWxSMha3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)