UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZK95uM2Set4UHqBBU5e34scodTgHDmSD5vC5VWB7gCQ='
WHERE
key_id = 'bdcf54e0d5a348a8581f8f617df6f113e1380ed4dacb90f3bb0ef6f5c2bc6075'
AND (
token = 'ZK95uM2Set4UHqBBU5e34scodTgHDmSD5vC5VWB7gCQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)