UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hR5odM58u4nq6xvcRWInFpZuxDIsBsVF30mQWN4v1tE='
WHERE
key_id = 'a46a12ea36b2914051c21140499c7e7b8b39db5ff01b1030c4bb71675bcb904c'
AND (
token = 'hR5odM58u4nq6xvcRWInFpZuxDIsBsVF30mQWN4v1tE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)