UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kD2cHVFX4a0Qg3XHD2z1QtArD9rDDCbADTDJo+brd24='
WHERE
key_id = '81ee8170d8f9d44ed8b9413c5a76b21633ff8560317839518344264568468d29'
AND (
token = 'kD2cHVFX4a0Qg3XHD2z1QtArD9rDDCbADTDJo+brd24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)