UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8yA6k4UfD9FvmUwFcvkVrlYLx0N5ZcJlMSnKBKMHNwo='
WHERE
key_id = '445cb6901d69e4a91606a12c6c78a3c9d5c49f7b3bcc81212163e5a88091e515'
AND (
token = '8yA6k4UfD9FvmUwFcvkVrlYLx0N5ZcJlMSnKBKMHNwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)