UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7QpTMWDWzTQ5aMkGInm9yN3cR3b6Jnhe4CG+aLGVwdw='
WHERE
key_id = '8d3a6e2b590b75198ddf02008dde755592171215dc46f053e52d3585bd361798'
AND (
token = '7QpTMWDWzTQ5aMkGInm9yN3cR3b6Jnhe4CG+aLGVwdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)