UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6rwp9Pg/zvGgMzGKD5N0vPLUl8EgzFXRAoEb9OaB4C0='
WHERE
key_id = 'b0b4616719a7b5bae12c4531f7d3f4ca1f44f5cbbaeb1258374a85a133b92257'
AND (
token = '6rwp9Pg/zvGgMzGKD5N0vPLUl8EgzFXRAoEb9OaB4C0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)