UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8pIuIRvIcYwhntgKQHPfENYIwC8KKO0h0rnHzZ3nMmA='
WHERE
key_id = '371a6bff2b7a454fe1a7cc5adb1b97ff9670f627e7fa38ed844e92ce742ea189'
AND (
token = '8pIuIRvIcYwhntgKQHPfENYIwC8KKO0h0rnHzZ3nMmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)