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