UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b/hZhlDUKEQp8ygleOU9m94P3nBRD48WUxkAfLyVKhs='
WHERE
key_id = 'ccb00640d91a887c3f2702a74ace9a7ab5490d0953853cc6100598e6b3814ce7'
AND (
token = 'b/hZhlDUKEQp8ygleOU9m94P3nBRD48WUxkAfLyVKhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)