UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vtj2P4r+ORI0PtWk5XHBj1dVLWoouhsGRcsV6N0Z2NA='
WHERE
key_id = 'ecd23f9bc0b9044f5bb56d105374432c6e1156d452817c011b400a842dbb4391'
AND (
token = 'vtj2P4r+ORI0PtWk5XHBj1dVLWoouhsGRcsV6N0Z2NA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)