UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BNffhKmSgCwr/Zl1A1qZAz8ATknTajLyEIGTheDa9wo='
WHERE
key_id = 'fbe338ee524c7795bf50c7dd15986578dc9159cc2186bd2849c139b36c33210b'
AND (
token = 'BNffhKmSgCwr/Zl1A1qZAz8ATknTajLyEIGTheDa9wo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)