UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VNQD4W+X4XAfdmEJfMPpxvLvQwi+3eZMXe36yFzkDL8='
WHERE
key_id = 'c878e7b9934bee32cc33028615fa8c53cdd9c4d103ad0d8117a613e8e8e82b06'
AND (
token = 'VNQD4W+X4XAfdmEJfMPpxvLvQwi+3eZMXe36yFzkDL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)