UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/GbDgq0P2LBtdenk1hx8Isqnp1yHBTpQUyts5Pp/aqg='
WHERE
key_id = '2038460e9c40b166e06a53f85a6d1a0e2e4c5a372d8ca0fa182837bb6a7a6485'
AND (
token = '/GbDgq0P2LBtdenk1hx8Isqnp1yHBTpQUyts5Pp/aqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)