UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yQ07Iaxc/gi71Qs47k7nwuVKIwSQsVoOXoU+vlcHG6A='
WHERE
key_id = 'edec31fb0f4e1c02d7f5340e2ae7935f8c017473a1a847ef0d4aaba6ed4f6c0e'
AND (
token = 'yQ07Iaxc/gi71Qs47k7nwuVKIwSQsVoOXoU+vlcHG6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)