UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kL42Jl3Fb6Nr6pt6oD9XBEEVhxCzQ43sb41GR4iSk94='
WHERE
key_id = '31d45570d4a69f796aed7acf3c52e5a35d511ea7a685ae62f88c189fee7a4fd4'
AND (
token = 'kL42Jl3Fb6Nr6pt6oD9XBEEVhxCzQ43sb41GR4iSk94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)