UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0BPTNE+1xgWaTlo39Mb/dv/f0nq42YHIs/6/EDA8SwI='
WHERE
key_id = '6c951437ab520122aec068a52a714a20a4cb784bc55a9aa5f20c87b59d499a0e'
AND (
token = '0BPTNE+1xgWaTlo39Mb/dv/f0nq42YHIs/6/EDA8SwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)