UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vtJxDY+tLH5DxhzRM+L4qjngWjS4tgW7f9k2/e6uXm4='
WHERE
key_id = 'b02223a923c12e709491a5c1c725af1a519518ace46e61a242eb1f9870eefb7a'
AND (
token = 'vtJxDY+tLH5DxhzRM+L4qjngWjS4tgW7f9k2/e6uXm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)