UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5CKqGB1OHsmIDdPB60XCbKMr0Jz2/utceX4Uaznr2Cw='
WHERE
key_id = '3928f9ea20d99fe1efb2ac9b66f09544e9674f39a1f6696ac29ef97b570fe19a'
AND (
token = '5CKqGB1OHsmIDdPB60XCbKMr0Jz2/utceX4Uaznr2Cw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)