UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D65QgwQ8UsEE9WwYOekUbzeoH6aCEMfcjYBt3QeaTwo='
WHERE
key_id = '7a47fe40051aced2528ea98af2027dd5e80e5ac40bc08964ad400ef408aac525'
AND (
token = 'D65QgwQ8UsEE9WwYOekUbzeoH6aCEMfcjYBt3QeaTwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)