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