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