UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Apt1b+PqbC6r5TvnJodMyfvhRBkvBCTbSNxZ89l9r0='
WHERE
key_id = 'de8632fdef8eb31cab336855ce9901f3a4897ad85d2777857eacd8d68cbf6466'
AND (
token = '9Apt1b+PqbC6r5TvnJodMyfvhRBkvBCTbSNxZ89l9r0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)