UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/342ilAOj0DoIilT+onaDbmkrrAUnA9JI9OmvgLts3U='
WHERE
key_id = '40582782a3358789d741fe833499faa4aef78a34f0b6e35e61d10c22a2dea33f'
AND (
token = '/342ilAOj0DoIilT+onaDbmkrrAUnA9JI9OmvgLts3U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)