UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4UyBy7bb3s5Jj4kFPCDzGwXLW03mwrEQeNCHyCy6jsE='
WHERE
key_id = 'dee6c4ffdac8640c21c1d2af471a0a5d923ceadf7d4bcb9827240dce42116781'
AND (
token = '4UyBy7bb3s5Jj4kFPCDzGwXLW03mwrEQeNCHyCy6jsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)