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