UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V8gh10IY1TKdqL+02gmcZgao6Jafil//y8Rn9Y9E3us='
WHERE
key_id = '7e2c78bd22f6701d22119fb75489864a23b038a81017bad0d4712cfc6dfc2021'
AND (
token = 'V8gh10IY1TKdqL+02gmcZgao6Jafil//y8Rn9Y9E3us='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)