UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3COpF8MyrKukqJM46N+n/zcYYnCGZjMoiHqVHFLgtww='
WHERE
key_id = '97c9f7864d1c71d54103aec644bbbad18529a249e6b2b0275b5a204e699f1339'
AND (
token = '3COpF8MyrKukqJM46N+n/zcYYnCGZjMoiHqVHFLgtww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)