UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L1cDRVWDSuEliFOCLu/ZkKKxQxHnvomhiqXRH16fAvg='
WHERE
key_id = 'ff973df2f68e84c59863d59dc96c7825c4ae5a3b199e4744e7251a7826c57ba6'
AND (
token = 'L1cDRVWDSuEliFOCLu/ZkKKxQxHnvomhiqXRH16fAvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)